﻿CREATE TABLE [dbo].[SIPaperUserAnswer]
(
	[Id] INT NOT NULL PRIMARY KEY IDENTITY, 
    [WxUserId] BIGINT NOT NULL, 
    [OrderType] INT NOT NULL, 
    [OrderId] INT NOT NULL, 
    [DeptId] NVARCHAR(50) NOT NULL, 
    [DeptName] NVARCHAR(50) NOT NULL, 
    [TreatDate] DATETIME NOT NULL, 
    [Suggestion] NTEXT NULL, 
    [SubmitDt] DATETIME NOT NULL, 
    [Phone] NVARCHAR(20) NULL
)

GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'主键',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'SIPaperUserAnswer',
    @level2type = N'COLUMN',
    @level2name = N'Id'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'用户ID',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'SIPaperUserAnswer',
    @level2type = N'COLUMN',
    @level2name = N'WxUserId'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'订单类型：0-挂号订单 1-缴费订单',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'SIPaperUserAnswer',
    @level2type = N'COLUMN',
    @level2name = N'OrderType'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'订单编号',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'SIPaperUserAnswer',
    @level2type = N'COLUMN',
    @level2name = N'OrderId'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'就诊科室编号',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'SIPaperUserAnswer',
    @level2type = N'COLUMN',
    @level2name = N'DeptId'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'就诊科室',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'SIPaperUserAnswer',
    @level2type = N'COLUMN',
    @level2name = N'DeptName'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'就诊日期 ',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'SIPaperUserAnswer',
    @level2type = N'COLUMN',
    @level2name = N'TreatDate'
GO

GO

GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'建议',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'SIPaperUserAnswer',
    @level2type = N'COLUMN',
    @level2name = N'Suggestion'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'提交时间',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'SIPaperUserAnswer',
    @level2type = N'COLUMN',
    @level2name = N'SubmitDt'
GO

GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'电话',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'SIPaperUserAnswer',
    @level2type = N'COLUMN',
    @level2name = N'Phone'